package cn.gson.crm.model.mapper;

import cn.gson.crm.model.pojos.*;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CpMapper {
    /*public List<Pro> selectcp();
    //按条件查询
    public List<Pro> selectcx(@Param("name") String name,@Param("fenlei") String fenlei);
    */

    //分页查询
    public List<Pro> cplb(@Param("name") String name,@Param("fenlei") String fenlei);
    //查询类别下拉框
    public List<Category> lb();
    //按类别查询规格
    public List<Pro> cpgg(@Param("bb")String bb);

    //根据规格名id查询规格名
    public List<Specifications> guigeming(@Param("guigeid")Integer guigeid,@Param("guigezhiid")Integer guigezhiid);
    //根据规格值id查询规格值
//    public List<Specifications> guigezhi();

    public List<SpecifValue> ming(@Param("cpming")String cpming,@Param("lbming")String lbming);

    public List<Purchasexq> cgmx();

    public List<ProductXq> tupian(@Param("xqId")Integer xqId);
}
